<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
    <%@page import="java.sql.*"%>
    <%@page import="java.util.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<%
final  String driverClass    = "com.mysql.jdbc.Driver";
final  String connectionURL  = "jdbc:mysql://localhost:3306/realac_sMwm";
final  String userID         = "realac_root";
final  String userPassword   = "ROOT123";

Connection   con   = null;
String query = "SELECT * FROM user";

 Map data=new HashMap();

try {
	
	Class.forName  ("com.mysql.jdbc.Driver");
	con = DriverManager.getConnection  ( connectionURL, userID, userPassword );
    Statement stmt = con.createStatement ();
    ResultSet rs = stmt.executeQuery (query);
   
	int i=0;
	while(rs.next()){
    	%>
    	 <%=rs.getString("first_name") %>;
    	<% 
    }
    
} catch (ClassNotFoundException e1) {
	// TODO Auto-generated catch block
	//response.(e1.printStackTrace());
}
 %>
</body>
</html>